package com.bff.gaia.mix.api.xjoin.client.mysql.all;/*
 * Licensed to the Apache Software Foundation (ASF) under one or more
 * contributor license agreements.  See the NOTICE file distributed with
 * this work for additional information regarding copyright ownership.
 * The ASF licenses this file to You under the Apache License, Version 2.0
 * (the "License"); you may not use this file except in compliance with
 * the License.  You may obtain a copy of the License at
 *
 *    http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

import com.bff.gaia.api.java.typeutils.RowTypeInfo;
import com.bff.gaia.mix.api.xjoin.client.rdb.all.RdbAllReqRow;
import com.bff.gaia.mix.api.xjoin.core.side.FieldInfo;
import com.bff.gaia.mix.api.xjoin.core.side.JoinInfo;
import com.bff.gaia.mix.api.xjoin.core.side.SideTableInfo;
import com.bff.gaia.mix.api.xjoin.core.utils.DtStringUtil;
import com.bff.gaia.shaded.guava18.com.google.common.collect.Maps;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import java.sql.Connection;
import java.sql.DriverManager;
import java.util.List;
import java.util.Map;

/**
 * Project Name: gaia-parent
 * Description:
 * Data: 2019/7/20 9:39
 *
 * @author tiger
 * @version v1.0
 */
public class MysqlAllReqRow extends RdbAllReqRow {

	private static final long serialVersionUID = 2098635140857937717L;

	private static final Logger LOG = LoggerFactory.getLogger(MysqlAllReqRow.class);

	private static final String MYSQL_DRIVER = "com.mysql.jdbc.Driver";

	private static final String MYSQL_DRIVER_6 = "com.mysql.cj.jdbc.Driver";

	public MysqlAllReqRow(RowTypeInfo rowTypeInfo, JoinInfo joinInfo, List<FieldInfo> outFieldInfoList, SideTableInfo sideTableInfo) {
		super(rowTypeInfo, joinInfo, outFieldInfoList, sideTableInfo);
	}

	@Override
	public Connection getConn(String dbURL, String userName, String password) {
		try {
			Class.forName(MYSQL_DRIVER_6);
			//add param useCursorFetch=true
			Map<String, String> addParams = Maps.newHashMap();
			addParams.put("useCursorFetch", "true");
			String targetDbUrl = DtStringUtil.addJdbcParam(dbURL, addParams, true);
			return DriverManager.getConnection(targetDbUrl, userName, password);
		} catch (Exception e) {
			LOG.error("", e);
			throw new RuntimeException("", e);
		}
	}

	@Override
	public int getFetchSize() {
		return Integer.MIN_VALUE;
	}
}